Microsoft Excel External Data Source

This topic describes options and information specific to Microsoft Excel files, Deltek Cobra's CAP report, and ARES PRISM G2 data.

Acumen's interface with Microsoft Excel provides an open and flexible means of linking to external data. Any data that can be stored as an XLS or XLSX file can be imported into Acumen for analysis.

When you link to an Excel file, an Options dialog box displays. Use the fields in this dialog box to:

• Select the worksheet from the Excel file that you want to import.
• Create mappings between the columns in the XLS spreadsheet and the fields within your Acumen workbook. Excel fields are auto-mapped to Acumen fields if the field names are consistent between the two applications.

In addition to importing standard excel files, you can use the Microsoft Excel option in the Get External Data From menu group on the S1 // Projects tab to import ARES PRISM G2 or Deltek Cobra CAP Earned Value data.